SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038341 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038341 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65505,933748,1003741,308775,147927,53622,228131,1015685,277123,939150,154732,734268,303252,910867,1042976,597402,258916,740763,470938,729277,778458,734023,1045142,109944,255497,235695,28320,38419,94831,120773,552469,335737,484802,375134,1024564,788639,132051,122382,513032,164387,941046,354399,528541,928763,639047,554643,1017040,629587,505638,182074,709385,24034,201489,499991,74741,672685,34728,912183,782296,838172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]