SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250380 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250380 [ RunTime:0.007393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518216,465037,974191,982942,465479,993930,1014282,529296,1027476,810076,849791,244964,352322,606592,438314,290435,948495,450906,959110,644314,835996,52939,50628,85167,945324,45117,857846,110816,646648,25337,30869,600710,208306,257134,848160,796098,171828,727085,129740,1029577,69697,10835,642878,940981,480958,561220,69386,749825,299582,1033453,277290,806475,246792,510171,759887,707729,14279,1020174,312837,642971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]