SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594041 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594041 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505383,852776,880114,533408,839339,550814,311895,191683,794934,307762,760478,691112,895846,786457,243599,142329,796081,485371,356481,805583,465661,418946,780725,869580,251548,312804,525668,406855,327565,859420,555314,69761,634113,809509,242004,378054,600859,806392,1037525,14809,530419,656485,402576,383537,299657,887281,233103,982286,37020,178307,454579,560850,375358,286681,424268,534444,100243,634431,643475,464147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]