SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450616 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450616 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51100,513527,979350,814447,509314,724705,165398,887479,78192,646831,84786,317402,208505,886625,451119,741997,220911,124809,312424,9305,587266,1032516,1031182,472841,639714,871931,883546,633167,502716,462275,266219,279794,851233,279768,923452,35879,273378,144903,755876,1023010,133712,757330,867645,986077,422547,414193,1000585,993507,1027378,97813,263791,177063,353546,631260,681293,198965,743360,242533,909696,66882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]