SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53650 LIMIT 1 [ RunTime:0.002494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53650 [ RunTime:0.005695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159183,762371,915942,625309,896918,1006626,940037,205148,41360,942991,625682,667971,8162,367261,896814,98607,539985,261709,510155,835280,961154,412562,253952,504517,261773,843885,842876,481976,54246,534217,718771,40935,162671,210517,820455,171065,752740,811009,840011,804912,649018,275096,189669,2915,303465,16429,443408,930249,846675,240038,903756,138452,992121,57514,965343,509097,846069,548415,445404,693251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001277s ]