SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548703 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548703 [ RunTime:0.003558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622778,776720,362527,231449,834096,628550,363208,697113,195414,76608,55992,319501,870520,1007564,821999,688950,85261,558898,372287,34964,529992,607501,341366,977089,490199,29707,661718,35253,519776,336174,424834,120830,716909,745715,231296,723971,698879,406480,352612,340211,270870,499061,413394,106791,38896,143488,880625,293157,522104,867774,93303,368314,177647,397865,11853,22630,95513,246391,222719,389725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]