SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5482 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5482 [ RunTime:0.003358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401374,291691,654579,37321,172488,381648,31388,12169,167835,742283,704616,417890,1041975,255608,822614,813668,525753,838920,1045337,563171,116545,455635,266598,836627,88180,362498,860631,1028239,639449,580720,750447,796547,193750,884216,179382,685321,184779,459748,761249,862789,690344,497535,599977,432566,193904,264888,329845,768969,789745,1034185,223139,885355,518829,921052,175188,881438,434747,302060,306794,336985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]