SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311997 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311997 [ RunTime:0.002027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503044,379726,653765,854349,400565,933115,738159,105838,534559,985009,1030906,854085,742253,910235,586198,258179,200133,675928,542415,385795,515322,164547,686781,998281,950390,1015814,223295,350472,902587,553650,732826,488387,246740,102322,142812,259018,648413,649280,898970,343730,3415,688323,160255,737382,194243,199046,682685,90237,247726,155992,574008,177458,864408,776671,902088,109740,133083,197357,458838,566761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]