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` = 411251 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411251 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888001,568043,276413,248287,585939,542559,932771,926032,197389,806729,70760,736889,869306,696697,533204,335029,731940,919138,35747,883048,834475,462974,424583,766417,1033196,425853,583989,449007,759487,25803,147820,727518,860661,717240,755965,129421,366618,482731,1003311,170681,164363,555796,179644,835074,977013,353545,457409,241720,162922,382718,861596,816560,515088,474449,626476,646550,834220,370293,4021,909959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]