SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53157 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53157 [ RunTime:0.004353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404599,254108,156676,1048829,144873,536761,696956,780612,129207,372233,5552,528156,1032327,446812,802088,675358,978205,514972,58693,426023,415611,850814,988535,667883,54419,355961,355565,177259,905765,201538,189797,191382,333849,464929,897338,235657,411635,1001754,375619,959028,282285,988206,210745,271519,382259,703783,562688,239625,575837,665213,871872,82779,641790,846906,229529,958443,36267,311460,639317,779590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]