SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045401 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045401 [ RunTime:0.002394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621947,503105,573762,389787,28192,554916,261236,289221,901501,64249,865142,321182,635242,308112,606439,20796,613548,878630,854332,904438,520203,603878,451201,540361,171812,734393,521173,7592,943596,740850,467173,325821,704326,559091,141179,555229,974984,812988,283217,934854,199255,1048629,308359,783172,645409,486253,77712,163976,963418,751400,891385,1016867,741017,824287,280958,376947,24462,471843,733142,932815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]