SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104329 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104329 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714600,535601,780950,741203,643329,146814,357748,142325,388202,628897,831776,654171,781940,737143,905980,611618,36045,747705,816308,807574,325099,478411,266605,909899,938339,234450,331347,9667,362964,747704,479265,113380,798533,181311,1004880,169308,238141,222410,508153,1015467,98070,907591,611987,610734,416294,631353,495094,478025,754162,40896,389117,6762,875055,46676,86993,99526,539755,991238,179349,430762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000347s ]