SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004818s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505431 LIMIT 1 [ RunTime:0.001670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505431 [ RunTime:0.003835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96738,518708,496563,211385,327758,174628,149246,77575,863755,351596,952500,304559,443309,641033,362773,227853,642003,423626,892123,402932,74196,956986,358212,157814,982176,515246,514124,440153,218312,951681,306227,342746,248694,423550,778046,63288,102142,923174,642254,192645,1029544,387745,300060,592432,594438,492512,16714,894478,635383,710268,136022,118158,662576,55032,753469,374987,341875,73681,71625,772478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]