SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009523 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009523 [ RunTime:0.004226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192985,791812,334372,733324,366030,820192,943488,459649,476725,746189,583278,884569,638981,278855,773749,729960,636253,967238,33322,208838,320516,970448,74559,1027223,425719,554775,673653,91364,965618,502817,1008042,499528,536735,1038974,562343,373846,973259,1003170,301510,138012,1032996,606681,394003,192828,529418,258511,566456,669193,1001718,397611,467751,242033,550829,143139,527328,228109,738841,258914,261974,709687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]