SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306781 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306781 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378078,675948,166735,285347,965078,207403,438689,431269,972778,730651,527743,41562,120529,1004671,257149,756222,190219,796048,1044816,228541,1017430,660394,956666,476283,348359,362483,354315,286325,161281,498908,112042,894897,916381,147249,102996,121319,121582,798037,846128,816071,1044954,251941,108102,724149,937869,959573,1002956,1011972,675938,614276,903491,495183,977517,649053,412554,296296,392281,536363,22827,803503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]