SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485830 LIMIT 1 [ RunTime:0.001747s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485830 [ RunTime:0.011588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409170,416757,942767,438849,219621,220358,848695,122628,298057,567298,971415,856520,89092,546054,670638,347555,1030073,227249,474209,80735,968377,227231,1013686,769195,120524,521307,805053,429191,871692,821582,50335,271922,359880,755234,1027309,949279,428048,76264,751064,940292,630095,949188,594227,1030789,337879,600900,649016,686973,421229,903262,595954,519571,746767,929799,46254,184932,119412,1034848,727523,1037036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]