SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489840 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489840 [ RunTime:0.005454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60706,391284,758850,443843,243209,598381,516920,990165,790472,341671,944887,730090,909659,852287,277080,482710,988155,75291,1026220,174791,745530,621553,745992,593830,728877,363556,95128,610240,1036539,978409,696099,316163,63077,424290,237215,379254,139891,982411,386480,747264,208632,741689,365596,567922,615983,492821,951918,576211,545635,555289,515025,178349,133118,176858,740709,1028772,871716,977843,403469,312973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]