SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048552 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048552 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451149,974776,226466,840154,456880,618407,600652,380884,193047,530758,961343,753590,794831,220681,54530,782855,752308,607996,176700,758792,687371,716575,521177,259149,53386,452943,61405,963057,118935,692212,409627,986979,485267,1039733,487679,277622,23558,27980,355743,750597,172174,386823,396080,325584,750161,850482,544731,175774,272945,314547,31832,766285,23572,1012451,851092,456017,903029,764968,812301,412537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003675s ]