SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570117 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570117 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765772,129500,455316,118779,804389,981926,873365,784950,208113,404437,94073,1047288,39156,112185,543694,508281,725699,301064,732657,770418,161568,576139,326888,128119,221564,169558,569931,601028,559263,422406,98694,434502,99318,763549,603690,352365,915330,908520,494293,183378,834186,1013623,124763,804695,164610,492214,1007870,611592,150034,1007374,265406,111557,735980,656671,938772,988021,871468,750744,158187,623271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]