SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423151 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423151 [ RunTime:0.002269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813821,1033998,640590,194367,205075,959474,670290,163263,669330,820279,194270,703199,10889,185734,766403,21436,451884,655686,834854,757255,3941,63249,632282,974169,112621,806417,744974,714553,1028489,504825,647563,348450,637439,213621,459602,330937,886952,135183,600276,270415,98459,910583,662819,547923,946273,339110,748326,129957,239051,161559,749151,932453,876691,955074,906908,408547,470911,673142,577903,653681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]