SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464448 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464448 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812348,416913,925582,650625,52439,139659,920250,241151,465145,780993,574436,178475,544814,275599,803661,211604,487394,722825,448198,380579,577126,900418,538647,382150,393503,137149,763417,486670,658194,153914,600470,639484,298016,106766,786415,460946,335512,134986,702990,509995,128056,21892,412598,108432,974036,800115,948339,224811,335693,976539,622190,770195,915917,456243,537435,442982,322167,542355,774920,434827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]