SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045063 LIMIT 1 [ RunTime:0.000661s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045063 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800573,719772,237742,298649,27390,629504,678136,147400,330138,493009,128282,724503,113395,692437,838501,628039,308920,761178,1030090,506811,785548,878764,728516,795143,381612,248944,681570,793278,553195,462604,968708,803167,24743,364346,14214,14840,728901,849877,420007,677889,653920,167582,267667,868037,745566,599273,492836,996743,360169,1018374,1005824,875853,170850,909236,967619,93769,153794,60635,189829,883554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]