SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430812 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430812 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185918,972732,892984,296527,615026,26790,351057,125567,224077,910766,8988,299299,170748,82974,866277,1041433,424973,371403,107453,970001,835420,154882,700367,710025,748758,246293,933455,830650,980439,992310,796014,942827,911964,544756,272427,743285,505041,312937,369024,641882,412183,176541,760784,991655,934776,690009,1045533,787691,795755,523606,884619,358605,714006,297555,206434,155040,253243,38570,211261,448689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]