SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023688 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023688 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469970,321777,236439,261853,867399,859467,139914,370990,8945,403193,803334,750991,231082,874814,1002930,184277,94367,1025365,821352,745768,985032,170269,131768,341671,417941,207428,361952,519332,507787,790963,935844,320128,779648,694660,871707,899698,715177,355786,347240,212918,207118,243669,835953,585814,563569,417840,79344,1000941,1046939,237617,108895,607575,381950,823179,408816,440248,622863,830098,961329,582463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]