SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414954 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414954 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135303,793988,290715,411286,518123,168661,310105,999107,1028574,84976,379521,248572,164299,235106,1013139,641331,917520,212690,873966,673030,600552,280185,589280,887182,307233,523500,491801,236668,882793,986804,486775,264642,800027,396091,431094,685884,515299,180555,748142,993034,351439,901966,1047008,700447,43419,644699,838683,755895,92388,725842,820036,43777,479337,30712,604268,936842,37984,1039141,434949,218567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]