SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519861 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519861 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302057,150561,794608,393781,674710,655962,534272,673511,104450,996608,79162,119372,60005,1012803,880438,345762,371340,463510,803197,616378,405144,100518,794047,579267,246028,55868,111647,1013296,337122,767726,657509,80198,419748,117482,321530,84125,189603,888308,881245,853871,317192,467284,2273,272745,644349,735986,344937,393806,67928,767561,127593,933187,922134,489371,219339,555138,60575,550421,500582,370424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]