SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031059 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031059 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513482,406410,961051,1006172,640967,915224,993205,128705,114174,538874,396331,771869,638497,514280,195737,167255,951396,320793,648385,354664,807017,170100,493176,937408,547610,580479,526757,276380,580495,622768,181990,607867,69081,848696,1030815,921317,716363,184401,228781,777218,191633,304038,500077,538752,794232,966703,910187,717787,114856,672704,582679,494878,411355,55828,499439,104997,132809,605989,564518,936792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]