SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449827 LIMIT 1 [ RunTime:0.000573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449827 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034884,452416,858817,988434,717837,716474,577425,260645,723901,958931,799297,270390,788589,635264,150657,995397,424499,761979,720638,831090,393915,2922,589731,355124,233202,119769,17988,52111,833991,931097,1041669,280994,416145,650965,448890,925415,430868,518208,551589,137860,851626,721037,1020589,737942,462663,818669,641394,324,833850,633233,1006145,54112,169870,781787,534140,254231,218688,371124,382631,759530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]