SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4448 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4448 [ RunTime:0.002771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158832,569715,607131,751699,659125,706185,808146,185724,776664,563235,391693,295163,571365,516002,457660,77350,892061,145983,156742,455546,531519,944857,981462,249216,98366,116221,999923,382590,755203,770021,246808,642495,312192,701977,168620,926076,980179,763477,42405,998911,869006,992458,571573,198397,528732,369158,708966,209644,107500,716244,101961,938694,39625,126538,288271,550200,188562,692837,497018,615638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]