SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 994680 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 994680 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470987,404783,971090,848842,792995,182494,309464,468285,776436,181573,35729,481123,779786,488220,609579,282874,620805,225931,230762,147868,140735,161556,156463,162607,479726,296068,468703,971915,346161,290139,729483,621482,412431,365060,1026672,571431,106451,236544,649091,1041685,395372,798212,156663,207386,928407,271649,944554,941113,753745,629223,816901,269053,21984,658193,437784,226771,548033,477908,692779,6089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 994680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 994680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]