SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022976 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022976 [ RunTime:0.003258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565643,1015907,159700,17912,91540,326543,484503,361960,896465,552482,679042,129888,798984,445661,467882,94719,565252,584626,695383,756807,549750,646317,305452,415401,530768,548786,994557,346276,609069,541926,125554,306199,1026800,756499,940121,116557,1042906,338082,404314,3891,120506,476558,1003199,208159,723999,387905,830895,195125,606178,787601,583494,580545,363754,269686,196756,834985,131283,318924,937909,1003440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]