SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562553 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562553 [ RunTime:0.003834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335892,315545,640085,199556,884261,760118,732442,866888,146566,865305,36375,771191,262581,416598,861853,727166,115692,339198,789667,585833,430682,419563,15569,352394,159489,692986,173920,1020416,722376,500478,447794,943300,167088,1029344,556730,90424,428063,59983,344784,94663,182182,265286,938647,996578,555490,790721,657339,598900,585305,699158,893524,674700,76358,393607,121778,536546,667088,115281,84674,408352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]