SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405682 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405682 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905534,580303,862778,803807,958999,278122,572843,465943,467336,84617,942843,435268,938746,747764,761123,311868,394802,757250,116489,48934,448838,1035451,12958,479173,899643,254934,1042588,72929,999195,441379,865983,753346,511,269733,567421,583493,706747,940678,6089,843437,16802,103497,862665,375155,232317,426210,714223,337945,301825,1042802,885496,689078,627864,120912,536497,203801,808111,742073,637135,616132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]