SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407615 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407615 [ RunTime:0.002653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162995,844986,575698,444930,409051,798555,598792,208932,456315,800779,1024701,545833,362838,401754,698836,458460,797345,562053,946714,286496,112320,645386,26676,614421,774764,813921,100783,1024543,400663,529652,674212,112956,363007,963030,895355,156574,102356,192554,772267,503678,346158,972755,62847,781846,248382,78120,991287,200432,677576,952369,862567,897329,913455,574601,871342,349551,56911,476886,221630,1030488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]