SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426014 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426014 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162483,1020808,173671,398514,112680,924570,209954,102633,322902,209330,523745,27950,399907,162633,1000685,850771,389982,1011816,760238,340998,823023,423143,446770,314825,324769,47988,974989,709472,627564,786074,990639,636960,684143,1026449,768758,1036407,537388,466603,705417,124821,836556,427279,646551,350417,8441,520126,703093,1047559,336464,944196,1018876,148531,464504,785692,742246,996962,499866,1038456,277733,225666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]