SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002734s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 956770 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 956770 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800846,54181,546747,147937,77529,320849,410188,293086,398972,997554,53740,720004,47712,753137,17899,956579,952929,57596,798505,470797,452724,857656,24137,385091,250782,493048,580455,600208,832260,859510,574920,206561,349963,744051,865514,957925,642045,50726,103004,610952,380490,903779,149599,182904,206844,990008,218293,595030,918133,976625,337628,738485,84512,157108,531207,1041109,965643,728635,545586,845659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 956770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 956770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]