SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001541s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001686 LIMIT 1 [ RunTime:0.003676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001686 [ RunTime:0.003356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274062,211304,830055,1037082,732629,920113,380019,652526,596409,852130,288892,650781,293698,601379,253049,458285,7411,183571,201169,683307,770766,182778,349881,648139,513193,925531,143151,692096,426719,635466,156572,629469,573278,1010759,815412,514124,43552,508506,918447,646068,191090,507640,376314,314264,494414,985005,778253,714747,847959,646181,792018,1013257,840222,148736,922047,611650,652416,640429,638209,596894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]