SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505950 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505950 [ RunTime:0.002307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444643,1026806,276319,278217,354923,655512,670014,271472,220301,419943,544956,759077,389448,850583,882606,818325,870278,128571,593500,362378,536172,286554,752747,640959,505162,534144,303072,323255,916723,1027273,18367,711682,707373,219767,206414,218315,37495,799923,697091,973195,138583,370077,67660,124530,458901,368480,618128,991702,221864,855247,692836,374477,173767,906687,760376,703300,190774,130203,117607,562130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]