SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383392 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383392 [ RunTime:0.006361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436825,153157,424294,242110,969143,760482,639539,810931,113202,831383,255172,998880,163655,466670,448294,253836,496449,232452,572392,263708,786411,241491,823567,644056,474682,283620,596187,76780,952754,696154,1007641,939435,797080,654472,734754,174836,314277,686432,660563,246136,829091,264248,305503,770523,515762,855235,676966,895096,551090,463933,692128,806140,545651,1034675,355634,969530,542611,423970,961181,31410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001404s ]