SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505186 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505186 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516080,952519,825822,330814,443971,865830,900195,446503,916690,656462,523542,481742,1013400,557626,576029,395417,192962,677707,289037,432861,236453,623410,828819,852144,581316,27446,1042103,98995,131032,148362,103954,12945,157331,230178,667274,872172,262150,834106,1004437,469062,337086,785128,842205,1007168,625614,761299,139990,1023314,512881,87041,142505,544277,233375,884048,208553,752146,13385,626363,692471,225557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]