SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497318 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497318 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105985,516576,296960,3459,390534,302021,424765,1004512,819409,514358,722900,925346,94133,111928,231474,747761,427082,898999,295012,1010941,730339,342665,492699,88555,658733,988210,834052,309757,340457,851250,718273,716384,134961,447255,299367,66528,629602,978711,637808,294089,387160,257151,762551,168069,236307,668785,952717,923491,123711,846591,368256,887418,781032,539004,437281,58592,998342,645761,331325,68138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]