SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551532 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551532 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825576,640509,840520,695973,296361,309205,150508,845274,166349,1039909,28038,938950,537528,582887,1002622,453025,432598,369261,685888,978811,481871,491336,62628,1046108,4508,37496,745293,747050,803290,505457,449466,854147,431073,890098,821745,276620,766429,886945,601227,635300,735797,393238,205991,576103,248021,940980,325890,311292,622617,1026542,747424,222774,1048631,125449,107049,444695,54053,990815,1013157,42256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004746s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001021s ]