SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517513 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517513 [ RunTime:0.002261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683503,37778,190625,468955,119344,313545,544951,556126,120427,541513,133404,689810,43728,720315,116528,263949,56940,259362,252557,952614,452861,818890,733456,209910,726485,190047,351524,412898,26872,607201,372145,565194,1038566,619400,417080,944198,243462,950680,1021068,74133,9020,97108,695614,550166,18172,817071,276334,283562,493032,428381,959736,544800,917795,387262,1011344,508746,187304,723984,27896,562535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]