SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984482 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984482 [ RunTime:0.002291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482671,862251,568635,619361,301533,267711,847440,99306,974950,1036268,586726,56753,716818,855238,395716,924600,929957,405000,307715,370839,60159,473470,965534,6378,312491,378622,497680,968913,365075,924326,155924,879172,584501,594300,553256,296643,794624,814655,863022,791021,166580,432018,527936,854336,578064,632657,386635,493710,532193,140725,1035436,1048755,438239,695613,686188,602808,838688,246691,976650,869961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]