SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580812 LIMIT 1 [ RunTime:0.001783s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580812 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004958,617636,851221,475975,350007,588786,655842,185705,164692,251677,884158,380852,323453,735797,699650,344865,942783,564559,225947,876810,439297,616589,399752,527338,845891,583002,266114,284572,577404,1001029,617450,941267,1035938,927693,581753,725008,734586,943597,33550,82843,613698,593998,923642,307163,963293,474661,255628,976450,135507,429017,63709,391416,1038018,1048409,298752,931190,617864,677081,1039042,517383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]