SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014570 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014570 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664085,836256,250526,1003464,622007,894063,769222,301862,962477,110972,549122,528452,522940,727013,610471,819494,479163,940681,270579,986973,127941,1037383,793287,490833,982663,308838,339962,358891,249813,377942,698487,85556,80011,222884,494957,255783,715960,303983,686093,466753,295698,460594,877035,277017,474266,562873,121000,996301,143101,75052,589881,929049,974723,836038,288469,657446,250352,640817,423856,677012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]