SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454413 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454413 [ RunTime:0.004274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802785,102808,813172,337139,37066,411006,189848,694834,334482,621744,427903,541282,407226,32088,25478,1016054,629041,594443,550607,39429,892161,5787,599527,1011187,367089,425230,36514,955985,927523,891708,72436,214074,778987,408688,34550,41832,535817,161856,558679,754832,1012289,54332,459476,590810,529728,132755,331604,805532,99163,895559,64285,398785,957197,972718,329508,353875,496371,417893,176846,59795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]