SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517817 LIMIT 1 [ RunTime:0.001468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517817 [ RunTime:0.003916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218586,685333,180663,120047,177127,285045,646589,129412,525430,527163,704260,886391,575506,712085,926816,356788,105604,154169,267411,444990,1045330,263195,125356,853610,331378,203225,995440,382094,72378,787951,856401,682801,575464,103596,444697,156128,830181,468885,705944,494531,408214,342916,605346,936918,18963,393940,367108,165010,27799,247420,639971,403519,534786,655990,322053,678022,625913,404611,368400,826582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]