SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517430 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517430 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032580,314616,408322,342774,214479,1032295,264833,666232,683805,332432,520211,821297,79459,715134,126337,214751,693561,461152,506964,933684,131586,877828,920332,184564,916601,128943,592568,173937,390077,754676,172902,554336,475914,915758,770649,523095,872270,979270,743887,158802,194609,989997,864284,115768,965973,598053,302268,944412,883268,202018,557361,524051,113084,969726,420691,45680,804144,56117,6093,265844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]