SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325080 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325080 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563454,26021,97692,754885,280045,508880,840312,964367,636073,606005,871336,1015163,997088,986239,477530,667186,540200,405493,922779,776451,991853,138783,894788,442046,458951,215332,513100,633671,915116,432794,45553,961532,1033484,666866,552344,349406,239356,141005,18030,771563,586625,106031,806270,753099,911215,932040,324120,488078,975808,540609,562076,639396,381072,835617,379282,8211,694197,632941,224905,249831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]