SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56601 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56601 [ RunTime:0.003627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337013,409747,972154,762517,520523,1048596,436647,68156,116444,640277,699661,922683,165408,767432,932700,288243,927579,1041819,368704,1021670,553305,254637,220873,432699,573289,479130,762151,162477,1034386,770775,370152,765866,309237,901074,202225,332780,162089,909592,704525,527167,909478,835633,784597,169993,744596,956189,690181,166220,281824,685903,671115,697758,156324,972385,840587,712609,717053,636862,582397,161287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]