SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68106 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68106 [ RunTime:0.001385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825480,965790,20563,388106,310085,77308,87251,172059,682081,12264,616162,310923,1037730,94191,156525,457857,393106,508128,712904,475955,675332,882918,3251,343139,638909,813080,562085,760011,242535,676829,37809,821942,977203,505660,891621,65045,413822,22478,199092,590943,24545,683702,523479,242707,759241,586605,500016,448501,1038621,233908,942723,133672,209998,370731,575948,908521,907012,890071,921164,525359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]