SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001835s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399712 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399712 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425849,595527,243889,604317,376137,776374,27717,962062,923543,127846,373885,365593,717374,133555,977281,990191,693046,334119,170491,326929,347789,315940,426552,565136,13415,74192,430022,763760,50568,22367,601079,287638,566666,470993,4559,28503,697297,846985,563992,59435,192016,89884,617383,704738,825073,612445,635779,679441,881707,778621,116224,359620,947637,906015,644143,242710,514202,978412,137559,43849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]