SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467583 LIMIT 1 [ RunTime:0.001031s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467583 [ RunTime:0.004496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417219,540736,606935,678426,302988,56485,505293,160363,743727,102001,111203,871361,927591,486513,369380,164838,901840,372337,198410,26083,565965,197787,114962,154373,321949,700995,655584,1007293,444001,80312,489194,642363,25512,230590,131875,756238,478219,852794,100367,851813,349472,834403,718395,1038394,110982,697767,819096,729141,482043,90210,2159,54983,418324,111544,707002,515089,244627,702316,666454,97101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]