SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489816 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489816 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418302,652213,584668,323351,336010,411309,171628,265483,886761,930561,255524,901669,316959,1007139,452340,536304,506426,567236,749717,327630,364558,318692,555386,529073,331649,786533,436738,228792,1026354,462350,236133,884679,178620,184147,60197,671992,916350,200037,566821,164681,1038262,677477,82642,355347,896148,795586,988197,891870,319457,382675,589736,439077,289349,555063,519535,945443,4217,20423,588662,525381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]