SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102508 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102508 [ RunTime:0.004016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031777,918516,605160,756097,823607,423942,737383,625984,907930,162796,393589,950987,251632,969567,113793,35110,189750,49006,693280,865689,137066,460522,1018517,866752,873283,457097,1010095,724669,368568,300285,799911,808013,102947,315967,608982,942784,952514,616561,778123,749617,542988,689427,645569,145772,753304,257041,598478,552891,526219,956618,969762,610403,1010796,793263,1023000,115565,726717,398279,637392,716797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]