SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510644 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510644 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439289,639937,497350,265425,975565,979456,482625,560146,1028542,406758,1020639,672151,563519,788835,118778,482941,996101,289580,465336,972436,168836,717209,553724,661966,199703,109732,46313,435646,423829,980139,688959,583372,368780,729185,218198,851803,159018,591254,156647,684185,866599,257230,551805,289329,918568,293546,883084,838136,693571,394331,11720,808064,168791,59989,342753,668392,323246,75627,858601,433681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]