SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334083 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334083 [ RunTime:0.002854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625683,108667,650456,738581,81377,867206,316035,620437,255214,1001331,975711,145877,673615,728600,1021936,1037066,240195,517516,920553,241587,778189,811576,119510,96588,963527,90868,828624,623800,93065,482538,944705,185884,369485,911674,346245,621215,397978,505973,207713,504408,324105,581330,698366,393331,706799,390264,691462,423128,34074,472760,986218,804849,328028,55914,104586,323625,981320,816135,516993,575185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]