SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525220 LIMIT 1 [ RunTime:0.002302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525220 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289397,841768,486336,730468,460451,157617,72001,887277,1011077,586185,903512,534099,969798,429624,160614,981358,942061,100138,785195,306879,518353,842133,522873,366236,251913,313456,975206,372178,428271,115520,201068,975999,648285,180913,454315,532944,36675,990303,911510,167438,173329,6483,1031909,1047908,603619,1048426,668332,809817,815534,389195,348683,150777,206771,14729,309775,849981,920018,729238,294771,6935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]