SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104523 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104523 [ RunTime:0.002028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510521,1603,304178,111271,823132,945063,751966,80252,957604,371629,1003303,682535,763780,804485,759899,624120,875219,707951,471518,562875,756923,140121,38081,233591,868883,606030,403747,999224,779623,368230,665859,801126,956340,964209,1027145,99493,884135,84147,715362,81795,909736,449785,342353,331213,631584,836336,711383,280397,722264,805158,999310,760638,480369,681550,485166,769850,982164,594468,424864,737834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]