SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532713 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532713 [ RunTime:0.003332s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739926,393707,236089,509197,76609,877851,881342,353445,494132,881076,558614,689332,813325,880229,929590,519405,327114,558958,498471,623713,37216,343980,1013901,583263,892517,198137,108640,102505,984436,302170,389454,910352,851212,536568,633388,296486,216987,690853,997800,410860,916553,592479,182601,854570,656790,410212,998114,163592,1012543,690275,259107,347259,598894,780626,121437,667506,298450,191029,669044,243512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000935s ]