SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285912 LIMIT 1 [ RunTime:0.002363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285912 [ RunTime:0.005813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43818,222684,1023973,797190,38420,573827,558009,346359,554163,1001577,644588,103311,352386,1029799,676087,107380,1002254,680706,347070,750105,56408,822250,428677,144284,403141,565571,112534,1694,111610,474372,797985,1025271,995195,105113,204109,186906,139901,131185,836222,1030123,477207,101437,972068,808638,973164,317470,453355,325606,493317,712640,689222,541412,184185,84047,425224,483973,224211,245589,204037,172247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]