SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491010 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491010 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997754,751317,142595,733239,274229,348485,511388,156646,580506,100949,614656,31447,47832,681038,757322,598565,379688,768659,124850,862457,844588,215239,900313,332634,181166,1010052,866810,934411,658540,890664,286555,96154,859076,691798,960541,51688,540811,395078,712151,688955,378525,225747,502496,1046345,976960,994716,663275,265533,533095,134100,846908,687601,527983,18068,589846,274186,903883,317739,924916,624918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]