SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404685 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404685 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424096,442674,51355,519704,844595,206648,472882,194663,284760,420297,137211,505281,942082,790430,207159,531902,43571,404664,302317,505767,11533,760589,31890,104067,864126,665029,965469,419909,900902,831904,133985,882845,347910,511873,302844,350701,232182,559094,278592,437303,382834,533094,1003985,137950,771063,744102,694175,557728,303982,58450,311918,717690,947025,46288,873763,850832,250488,126595,888055,997663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]