SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56208 LIMIT 1 [ RunTime:0.001155s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56208 [ RunTime:0.005460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715255,82571,362483,314203,683728,467609,18802,961512,74970,130188,613831,507528,471268,832518,280075,361980,387869,665442,221278,114100,679409,685604,64664,442562,102284,688890,459187,403896,719283,585831,592128,783654,895029,915540,495786,755461,310931,716807,353095,595537,6107,338853,519935,506311,326756,286355,631022,176270,874303,886365,555804,536263,331937,1012532,231543,978664,873708,655620,538439,1005583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]